2017-06-27 - 43803 - Break Fix - Supplier Portal XPO carton labels #CrystalReportsSupport
BREAK FIX
43803 - Supplier Portal XPO carton labels
Problem Summary
Need to check blank data issue in SNC160 report.
Admin Info
Purpose
|
Need to check blank data issue in SNC160 report.
|
Requested by
|
Saravanan Lakshmanan
|
Issue Date
|
06-27-2017
|
Resolved by
|
Dhananjay G
|
Resolved Date
|
07-07-2017
|
Document Status
|
Complete
|
Detailed Problem Description
Email from Saravanan Lakshmanan on 06/27/2017:
The below PO's having blank data in SNC160 report, need to check the logic:
4500195328
4500195329
4500195925
4500195114
4500196289
4500189492
4500194046
4500189423
4500196737
4500197329
4500193618
Solution Analysis and Recommendations
1. Need to check the logic in the report.
2. Need to check the table joins.
3. Need to validate the reports with SAP Tables.
4. Need to place the report in BI development and inform NEC for promotion after successful validation.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Resolution
1. Added the table join for getting data with provided PO's:
ZFM_PACKING.T_T_DETAIL_POSNR --> EKET.EBELP
2. Removed the following table joins in the report:
ZFM_PACKING.T_T_DETAIL_VBELN --> EKET.J_3AUANR
ZFM_PACKING.T_T_DETAIL_VBELN --> EKET.J_3AUPOS
MAKT.MANDT --> VBAK.MANDT
3. All the scenarios are tested with users by NEC.
Release Information
None